{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":182,"n_cols":12,"rows_kept":182,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[22,2,22,3],[40,2,40,3],[58,2,58,3],[75,2,75,3],[93,2,93,3],[110,2,110,3],[128,2,128,3],[145,2,145,3],[163,2,163,3],[180,2,180,3],[181,2,181,4]]}
["Школа",null,"МАОУ \"Лицей №10\" г. Альметьевска",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Мингазова Г.Г."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",2,3,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Сырники из творога с кашей молочной \"Дружба\" с маслом сливочным",215,10.55,11.85,39.4,324.45,"ТТК"]
[{"$nulls":3},"гор.напиток","Кофейный напиток с молоком",200,3.1660000000000004,2.6780000000000004,6,60.7,"№379"]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.9799999999999998,0.36,11.88,59.4,"табл№6"]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,"табл №9"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F11)","v":545},{"$f":"SUM(G6:G11)","v":16.096},{"$f":"SUM(H6:H11)","v":15.288},{"$f":"SUM(I6:I11)","v":67.08},{"$f":"SUM(J6:J11)","v":491.54999999999995},null,77.76]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F13:F21)","v":0},{"$f":"SUM(G13:G21)","v":0},0,0,0,null,{"$f":"SUM(L13:L21)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F12+F22","v":545},{"$f":"G12+G22","v":16.096},15.288,67.08,491.54999999999995,null,{"$f":"L12+L22","v":77.76}]
[1,2,"Завтрак","гор.блюдо","Птица запеченная",100,10.42,12.43,8.65,192,"ТТК"]
[{"$nulls":3},"гарнир","Пюре картофельное с маслом сливочным",153,3.0765,6.2535,20.466999999999995,150.45,"№312"]
[{"$nulls":3},"гор.напиток","Напиток из свежих фруктов ",200,0.34,0.17,21.46,103.5,"ТТК"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.5,"табл №6"]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.9799999999999998,0.36,11.88,59.4,"табл №6"]
[{"$nulls":3},"салат","Свекла отварная дольками",60,1.08,0.06,5.88,28.8,"ТТК"]
[{"$nulls":3},"итого",null,573,19.176499999999997,19.513499999999997,83.097,604.65,null,77.76]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого"]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Итого за день:",null,null,{"$f":"F30+F40","v":573},{"$f":"G30+G40","v":19.176499999999997},{"$f":"H30+H40","v":19.513499999999997},{"$f":"I30+I40","v":83.097},{"$f":"J30+J40","v":604.65},null,77.76]
[1,3,"Завтрак","гор.блюдо","Гуляш из говядины",100,10.39,14.79,10.3,221,"№260"]
[{"$nulls":3},"гарнир","Каша гречневая рассыпчатая",150,3.77,2.290000000000001,39.72,214,"№171"]
[{"$nulls":3},"гор.напиток","Чай с сахаром, с лимоном ",200,0.112,0.018000000000000002,10.149999999999999,41.32,"№377"]
[{"$nulls":3},"хлеб","Хлеб ржаной",50,3.3,0.6000000000000001,19.800000000000004,99.00000000000003,"табл №6"]
[{"$nulls":3},"сыр","Сыр порционно",10,2.63,2.66,0,34.333333333333336,"№15"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F42:F47)","v":510},{"$f":"SUM(G42:G47)","v":20.201999999999998},{"$f":"SUM(H42:H47)","v":20.358},{"$f":"SUM(I42:I47)","v":79.97},{"$f":"SUM(J42:J47)","v":609.6533333333334},null,77.76]
[{"$f":"A42","v":1},{"$f":"B42","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F49:F57)","v":0},{"$f":"SUM(G49:G57)","v":0},{"$f":"SUM(H49:H57)","v":0},{"$f":"SUM(I49:I57)","v":0},{"$f":"SUM(J49:J57)","v":0},null,0]
[{"$f":"A42","v":1},{"$f":"B42","v":3},"Итого за день:",null,null,{"$f":"F48+F58","v":510},{"$f":"G48+G58","v":20.201999999999998},{"$f":"H48+H58","v":20.358},{"$f":"I48+I58","v":79.97},{"$f":"J48+J58","v":609.6533333333334},null,77.76]
[1,4,"Завтрак","гор.блюдо","Жаркое по домашнему с индейкой",200,15.33,16.99,34.77,335.2,"ТТК"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"гор.напиток","Напиток из шиповника",200,0.68,0.28,20.76,88.2,"ТТК"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",40,2.28,0.24,14.76,70.5,"табл №6"]
[{"$nulls":3},"салат","Салат из квашенной капусты",60,1.02,3,5.07,51.42,"ТТК"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F60:F64)","v":500},{"$f":"SUM(G60:G64)","v":19.310000000000002},{"$f":"SUM(H60:H64)","v":20.509999999999998},{"$f":"SUM(I60:I64)","v":75.36000000000001},{"$f":"SUM(J60:J64)","v":545.3199999999999},null,77.76]
[{"$f":"A60","v":1},{"$f":"B60","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F66:F74)","v":0},{"$f":"SUM(G66:G74)","v":0},{"$f":"SUM(H66:H74)","v":0},{"$f":"SUM(I66:I74)","v":0},{"$f":"SUM(J66:J74)","v":0},null,0]
[{"$f":"A60","v":1},{"$f":"B60","v":4},"Итого за день:",null,null,{"$f":"F65+F75","v":500},{"$f":"G65+G75","v":19.310000000000002},{"$f":"H65+H75","v":20.509999999999998},{"$f":"I65+I75","v":75.36000000000001},{"$f":"J65+J75","v":545.3199999999999},null,77.76]
[1,5,"Завтрак","гор.блюдо","Котлета из мяса птицы с макаронными изделиями отварными, с маслом сливочным",230,11.45,12.46,31.32,289.95,"ТТК"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов ",200,0.662,0.09000000000000001,22.034000000000002,92.80000000000001,"№349"]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.9799999999999998,0.36,11.88,59.4,"табл №6"]
[{"$nulls":3},"салат","Икра кабачковая",60,0.64,3.31,5.03,50.28,"ТТК"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F77:F82)","v":520},{"$f":"SUM(G77:G82)","v":14.732000000000001},{"$f":"SUM(H77:H82)","v":16.22},{"$f":"SUM(I77:I82)","v":70.264},{"$f":"SUM(J77:J82)","v":492.42999999999995},null,77.76]
[{"$f":"A77","v":1},{"$f":"B77","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F84:F92)","v":0},{"$f":"SUM(G84:G92)","v":0},{"$f":"SUM(H84:H92)","v":0},{"$f":"SUM(I84:I92)","v":0},{"$f":"SUM(J84:J92)","v":0},null,0]
[{"$f":"A77","v":1},{"$f":"B77","v":5},"Итого за день:",null,null,{"$f":"F83+F93","v":520},{"$f":"G83+G93","v":14.732000000000001},{"$f":"H83+H93","v":16.22},{"$f":"I83+I93","v":70.264},{"$f":"J83+J93","v":492.42999999999995},null,77.76]
[2,1,"Завтрак","гор.блюдо","Сырники из творога с кашей пшенной молочной с маслом сливочным",245,16.02,18.13,42.98,386.4,"ТТК"]
[{"$nulls":3},"гор.напиток","Чай Витаминный с шиповником",200,0.235,0.09,12.424999999999999,54.2,"№376"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.75,"табл №6"]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.9799999999999998,0.36,11.88,59.4,"табл №6"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F95:F99)","v":500},{"$f":"SUM(G95:G99)","v":20.134999999999998},{"$f":"SUM(H95:H99)","v":18.779999999999998},{"$f":"SUM(I95:I99)","v":79.585},{"$f":"SUM(J95:J99)","v":558.75},null,77.76]
[{"$f":"A95","v":2},{"$f":"B95","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F101:F109)","v":0},{"$f":"SUM(G101:G109)","v":0},0,0,0,null,{"$f":"SUM(L101:L109)","v":0}]
[{"$f":"A95","v":2},{"$f":"B95","v":1},"Итого за день:",null,null,{"$f":"F100+F110","v":500},{"$f":"G100+G110","v":20.134999999999998},{"$f":"H100+H110","v":18.779999999999998},{"$f":"I100+I110","v":79.585},{"$f":"J100+J110","v":558.75},null,77.76]
[2,2,"Завтрак","гор.блюдо","Овощи тушеные с мясом",200,12.475,15.68,19.334999999999997,271.5,"№143"]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов ",200,0.662,0.09000000000000001,22.034000000000002,92.80000000000001,"№349"]
[{"$nulls":3},"хлеб","Хлеб ржаной",20,1.32,0.24000000000000002,7.920000000000002,39.60000000000001,"табл №6"]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (апельсины)",180,1.62,0.36,14.58,77.4,"табл №9"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F112:F117)","v":600},{"$f":"SUM(G112:G117)","v":16.077},{"$f":"SUM(H112:H117)","v":16.369999999999997},{"$f":"SUM(I112:I117)","v":63.869},{"$f":"SUM(J112:J117)","v":481.30000000000007},null,77.76]
[{"$f":"A112","v":2},{"$f":"B112","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F119:F127)","v":0},{"$f":"SUM(G119:G127)","v":0},0,0,0,null,{"$f":"SUM(L119:L127)","v":0}]
[{"$f":"A112","v":2},{"$f":"B112","v":2},"Итого за день:",null,null,{"$f":"F118+F128","v":600},{"$f":"G118+G128","v":16.077},{"$f":"H118+H128","v":16.369999999999997},{"$f":"I118+I128","v":63.869},{"$f":"J118+J128","v":481.30000000000007},null,77.76]
[2,3,"Завтрак","гор.блюдо","Котлета из мяса птицы с макаронными изделиями отварными, с маслом сливочным",230,11.45,12.46,31.32,289.95,"ТТК"]
[{"$nulls":3},"гор.напиток","Какао с молоком",200,1.58,3.544,7.597999999999999,78.60000000000001,"№382"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.75,"табл №6"]
[{"$nulls":3},"салат","Салат из зеленого горошка к/с",60,1.09,1.31,16.95,60.16,"ТТК"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F130:F134)","v":515},{"$f":"SUM(G130:G134)","v":16.02},{"$f":"SUM(H130:H134)","v":17.514},{"$f":"SUM(I130:I134)","v":68.168},{"$f":"SUM(J130:J134)","v":487.46000000000004},null,77.76]
[{"$f":"A130","v":2},{"$f":"B130","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F136:F144)","v":0},{"$f":"SUM(G136:G144)","v":0},0,0,0,null,{"$f":"SUM(L136:L144)","v":0}]
[{"$f":"A130","v":2},{"$f":"B130","v":3},"Итого за день:",null,null,{"$f":"F135+F145","v":515},{"$f":"G135+G145","v":16.02},{"$f":"H135+H145","v":17.514},{"$f":"I135+I145","v":68.168},{"$f":"J135+J145","v":487.46000000000004},null,77.76]
[2,4,"Завтрак","гор.блюдо","Плов из говядины с рисовой крупой",200,15.9,19.55,39.745,408.42,"№265"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.07,0.02,10.01,40,"№376"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.75,"табл №6"]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,"табл №9"]
[{"$nulls":3},"хлеб","Хлеб ржаной",20,1.32,0.24000000000000002,7.920000000000002,39.60000000000001,"табл №6"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F147:F152)","v":545},{"$f":"SUM(G147:G152)","v":19.59},{"$f":"SUM(H147:H152)","v":20.409999999999997},{"$f":"SUM(I147:I152)","v":79.77499999999999},{"$f":"SUM(J147:J152)","v":593.7700000000001},null,77.76]
[{"$f":"A147","v":2},{"$f":"B147","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F154:F162)","v":0},{"$f":"SUM(G154:G162)","v":0},0,0,0,null,{"$f":"SUM(L154:L162)","v":0}]
[{"$f":"A147","v":2},{"$f":"B147","v":4},"Итого за день:",null,null,{"$f":"F153+F163","v":545},{"$f":"G153+G163","v":19.59},{"$f":"H153+H163","v":20.409999999999997},{"$f":"I153+I163","v":79.77499999999999},{"$f":"J153+J163","v":593.7700000000001},null,77.76]
[2,5,"Завтрак","гор.блюдо","Биточки рыбные с картофельным пюре, с маслом сливочным",228,12.2,12.49,31.4,290.55,"ТТК"]
[{"$nulls":3},"гор.напиток","Компот из свежих яблок (75С)",200,0.16000000000000003,0.16000000000000003,17.900000000000002,74.60000000000001,"№342"]
[{"$nulls":3},"хлеб","Хлеб ржаной",20,1.32,0.24,7.92,39.6,"табл №6"]
[{"$nulls":3},"салат","Салат из отварной свеклы с сыром",60,1.84,3.7,9.78,78.42,"ТТК",77.76]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F165:F169)","v":508},{"$f":"SUM(G165:G169)","v":15.52},{"$f":"SUM(H165:H169)","v":16.59},{"$f":"SUM(I165:I169)","v":67},{"$f":"SUM(J165:J169)","v":483.1700000000001},null,{"$f":"SUM(L165:L169)","v":77.76}]
[{"$f":"A165","v":2},{"$f":"B165","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F171:F179)","v":0},{"$f":"SUM(G171:G179)","v":0},0,0,0,null,{"$f":"SUM(L171:L179)","v":0}]
[{"$f":"A165","v":2},{"$f":"B165","v":5},"Итого за день:",null,null,{"$f":"F170+F180","v":508},{"$f":"G170+G180","v":15.52},{"$f":"H170+H180","v":16.59},{"$f":"I170+I180","v":67},{"$f":"J170+J180","v":483.1700000000001},null,77.76]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F41+F59+F76+F94+F111+F129+F146+F164+F181)/(IF(F23=0,0,1)+IF(F41=0,0,1)+IF(F59=0,0,1)+IF(F76=0,0,1)+IF(F94=0,0,1)+IF(F111=0,0,1)+IF(F129=0,0,1)+IF(F146=0,0,1)+IF(F164=0,0,1)+IF(F181=0,0,1))","v":531.6},{"$f":"(G23+G41+G59+G76+G94+G111+G129+G146+G164+G181)/(IF(G23=0,0,1)+IF(G41=0,0,1)+IF(G59=0,0,1)+IF(G76=0,0,1)+IF(G94=0,0,1)+IF(G111=0,0,1)+IF(G129=0,0,1)+IF(G146=0,0,1)+IF(G164=0,0,1)+IF(G181=0,0,1))","v":17.685850000000002},{"$f":"(H23+H41+H59+H76+H94+H111+H129+H146+H164+H181)/(IF(H23=0,0,1)+IF(H41=0,0,1)+IF(H59=0,0,1)+IF(H76=0,0,1)+IF(H94=0,0,1)+IF(H111=0,0,1)+IF(H129=0,0,1)+IF(H146=0,0,1)+IF(H164=0,0,1)+IF(H181=0,0,1))","v":18.155350000000002},{"$f":"(I23+I41+I59+I76+I94+I111+I129+I146+I164+I181)/(IF(I23=0,0,1)+IF(I41=0,0,1)+IF(I59=0,0,1)+IF(I76=0,0,1)+IF(I94=0,0,1)+IF(I111=0,0,1)+IF(I129=0,0,1)+IF(I146=0,0,1)+IF(I164=0,0,1)+IF(I181=0,0,1))","v":73.4168},{"$f":"(J23+J41+J59+J76+J94+J111+J129+J146+J164+J181)/(IF(J23=0,0,1)+IF(J41=0,0,1)+IF(J59=0,0,1)+IF(J76=0,0,1)+IF(J94=0,0,1)+IF(J111=0,0,1)+IF(J129=0,0,1)+IF(J146=0,0,1)+IF(J164=0,0,1)+IF(J181=0,0,1))","v":534.8053333333334},null,{"$f":"(L23+L41+L59+L76+L94+L111+L129+L146+L164+L181)/(IF(L23=0,0,1)+IF(L41=0,0,1)+IF(L59=0,0,1)+IF(L76=0,0,1)+IF(L94=0,0,1)+IF(L111=0,0,1)+IF(L129=0,0,1)+IF(L146=0,0,1)+IF(L164=0,0,1)+IF(L181=0,0,1))","v":77.76}]